package org.steven.crm.core.query;

import com.steven.xdb.pagination.query.AbstractQueryDataList;

public class SaleBillQueryDataList extends AbstractQueryDataList {

	@Override
	public void init() {
		setTableOrView("saleBill_V");
		setColumns("*");
		setConditionRelation("and");
		setQueryWithNoCondition(true);
		setPageNumber(20);

		addQueryCondition("customerId", "=", "$customerId$");
		addQueryCondition("customerName", "like", "%$customerName$%");
		addQueryCondition("customerLinkman", "like", "%$customerLinkman$%");
		addQueryCondition("customerLinkPhone", "like", "%$customerLinkPhone$%");
		addQueryCondition("customerName_customerLinkman_customerLinkPhone", "like", "%$customerName_customerLinkman_customerLinkPhone$%");
		addQueryCondition("billDate", "=", "$billDate$");
	}
}
